#!/bin/bash
sqlplus /nolog << EOF
conn / as sysdba
insert into student(sno,sname,ssex,sage,sdept) values(92125,'yang',1,21,'ruanyuan');
insert into sc(sno,cno,grade) values(92125,3,80);
update student set ssex=0 where sname='hairui';
select * from sc where sno in(select sno from student where sname='hairui');
exit
EOF
